Fixed Assets Tables
Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.
tblFaAsset -- FA Asset table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
AssetID | pAssetID | 15 | |||
AssetPrefix | nvarchar | 9 | |||
TaxDist1 | nvarchar | 15 | |||
TaxDist2 | nvarchar | 15 | |||
TaxDist3 | nvarchar | 15 | |||
Locat1 | nvarchar | 15 | |||
Locat2 | nvarchar | 15 | |||
Locat3 | nvarchar | 15 | |||
AssetStatus | tinyint | 1 | -1 | Asset Status | 1 = Active, 2 = Retired, 3 = New, 4 = Suspended |
OwnedAsset | bit | 1 | Owned / Leased Asset Flag | 0 = Leased, 1 = Owned | |
NewAsset | bit | 1 | New / Used Asset Flag | 0 = Used, 1 = New | |
PersonalProperty | bit | 1 | Personal / Real Estate Asset Flag | 0 = Real Estate, 1 = Personal | |
ListedProperty | bit | 1 | |||
InsurableProperty | bit | 1 | |||
AssetClass | nvarchar | 6 | |||
TaxClass | nvarchar | 4 | |||
GLAsset | pGlAcct | 255 | |||
GLAccum | pGlAcct | 255 | |||
GLExpense | pGlAcct | 255 | |||
AcquisitionCost | pDecimal | 13 | 0 | ||
AcquisitionDate | datetime | 8 | |||
RetirementDate | datetime | 8 | |||
Qty | int | 4 | 0 | ||
InsuredValue | pDecimal | 13 | 0 | ||
InsuredValueDate | datetime | 8 | |||
AssessedValue | pDecimal | 13 | 0 | ||
AssessedValueDate | datetime | 8 | |||
ReplaceCost | pDecimal | 13 | 0 | ||
ReplaceCostDate | datetime | 8 | |||
PlacedInServDate | datetime | 8 | |||
TaxPaid | pDecimal | 13 | 0 | ||
AccumNonDeprcCost | pDecimal | 13 | 0 | ||
AdjustedCost | pDecimal | 13 | 0 | ||
AdjustedDate | datetime | 8 | |||
TotalCredits | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
AssetDescr | pDescription | 255 | |||
BonusDeprPct | pDecimal | 13 | 0 | ||
CreditDescr | pDescription | 255 | |||
Manufacturer | pDescription | 255 | |||
ModelNo | pDescription | 255 | |||
NoteField | varchar | max | |||
SerialNo | pDescription | 255 | |||
TagNo | pDescription | 255 | |||
*CurrencyID | pCurrency | 6 |
tblFaAssetDepr -- FA Asset Depreciation table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
AssetID | pAssetID | 15 | |||
DeprcType | nvarchar | 6 | |||
Method | nvarchar | 6 | |||
AppyBusinessUse | tinyint | 1 | -1 | ||
SwitchMethod | nvarchar | 6 | |||
BeginYr | int | 4 | |||
BeginPd | smallint | 2 | |||
EndYr | int | 4 | |||
EndPd | smallint | 2 | |||
Life | pDecimal | 13 | |||
Recovery | int | 4 | |||
BaseCost | pDecimal | 13 | |||
SalvageValue | pDecimal | 13 | |||
BonusDepr | pDecimal | 13 | |||
Expense179 | pDecimal | 13 | |||
Credits | pDecimal | 13 | |||
TotDeprElig | pDecimal | 13 | |||
AnnualDepr | pDecimal | 13 | |||
CurrDepr | pDecimal | 13 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblFaAssetDeprActivity -- FA Asset Depreciation Activity table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Amount | pDecimal | 13 | |||
DeprID | int | 4 | |||
EntryDate | datetime | 8 | |||
FiscalPeriod | smallint | 2 | |||
FiscalYear | smallint | 2 | |||
GLAccumDepr | pGlAcct | 40 | |||
GLExpense | pGlAcct | 40 | |||
ID | int | 4 | |||
PostRun | pPostRun | 14 | |||
TransDate | datetime | 8 | |||
TransType | smallint | 2 | Transaction Type | 0 = Regular Depreciation, 1 = Retirement Depreciation | |
ts | timestamp | 8 | |||
CF | xml | -1 | |||
*AmountBase | pDecimal | 13 |
tblFaAssetService -- FA Asset Service table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
AssetID | pAssetID | 15 | |||
ServiceDateSched | datetime | 8 | |||
ServiceDateAct | datetime | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ServDescr | pDescription | 255 |
tblFaOptionDepr
-- FA Optional Depreciation table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
DeprType | nvarchar | 6 | |||
PdInYr | smallint | 2 | |||
PdProcessed | smallint | 2 | |||
BeginPd | smallint | 2 | |||
EndPd | smallint | 2 | |||
FiscalYear | smallint | 2 | |||
GLPd | smallint | 2 | |||
Process | tinyint | 1 | |||
SortOrder | smallint | 2 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
Type | tinyint | 1 | Depreciation Type | 0 = Other, 1 = Book, 2 = FedTax, 3 = AltMinTax |
tblFaRetire -- FA Asset Retirement table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
RetirementID | int | 4 | |||
AssetID | pAssetID | 15 | |||
AssetPrefix | nvarchar | 9 | |||
TaxDist1 | nvarchar | 15 | |||
TaxDist2 | nvarchar | 15 | |||
TaxDist3 | nvarchar | 15 | |||
Locat1 | nvarchar | 15 | |||
Locat2 | nvarchar | 15 | |||
Locat3 | nvarchar | 15 | |||
AssetStatus | tinyint | 1 | 0 | Asset Status | 1 = Active, 2 = Retired, 3 = New, 4 = Suspended |
OwnedAsset | bit | 1 | |||
NewAsset | bit | 1 | |||
PersonalProperty | bit | 1 | |||
ListedProperty | bit | 1 | |||
InsurableProperty | bit | 1 | |||
AssetClass | nvarchar | 6 | |||
TaxClass | nvarchar | 4 | |||
GLAsset | pGlAcct | 255 | |||
GLAccum | pGlAcct | 255 | |||
GLExpense | pGlAcct | 255 | |||
AcquisitionCost | pDecimal | 13 | 0 | ||
AcquisitionDate | datetime | 8 | |||
RetirementDate | datetime | 8 | |||
Qty | int | 4 | 0 | ||
InsuredValue | pDecimal | 13 | 0 | ||
InsuredValueDate | datetime | 8 | |||
AssessedValue | pDecimal | 13 | 0 | ||
AssessedValueDate | datetime | 8 | |||
ReplaceCost | pDecimal | 13 | 0 | ||
ReplaceCostDate | datetime | 8 | |||
PlacedInServDate | datetime | 8 | |||
TaxPaid | pDecimal | 13 | 0 | ||
AccumNonDeprcCost | pDecimal | 13 | 0 | ||
AdjustedCost | pDecimal | 13 | 0 | ||
AdjustedDate | datetime | 8 | |||
TotalCredits | pDecimal | 13 | 0 | ||
RetireCode | nvarchar | 1 | |||
RetireDate | datetime | 8 | |||
RetireQty | int | 4 | 0 | ||
RetireAmt | pDecimal | 13 | 0 | ||
RetireProceeds | pDecimal | 13 | 0 | ||
RetireExpense | pDecimal | 13 | 0 | ||
RetireCredits | pDecimal | 13 | 0 | ||
RetireAcqCosts | pDecimal | 13 | 0 | ||
AssetDescr | pDescription | 255 | |||
BonusDeprPct | pDecimal | 13 | 0 | ||
CreditDescr | pDescription | 255 | |||
Manufacturer | pDescription | 255 | |||
ModelNo | pDescription | 255 | |||
NoteField | varchar | max | |||
RetireReason | pDescription | 255 | |||
SerialNo | pDescription | 255 | |||
TagNo | pDescription | 255 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*CurrencyID | pCurrency | 6 |
tblFaRetireDepr -- FA Asset Retirement Depreciation table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
RetirementID | int | 4 | |||
AssetID | pAssetID | 15 | |||
DeprcType | nvarchar | 6 | |||
Method | nvarchar | 6 | |||
AppyBusinessUse | tinyint | 1 | -1 | ||
SwitchMethod | nvarchar | 6 | |||
BeginYr | int | 4 | |||
BeginPd | smallint | 2 | |||
EndYr | int | 4 | |||
EndPd | smallint | 2 | |||
Life | pDecimal | 13 | |||
Recovery | int | 4 | |||
ActLife | int | 4 | |||
BaseCost | pDecimal | 13 | |||
SalvageValue | pDecimal | 13 | |||
BonusDepr | pDecimal | 13 | |||
Expense179 | pDecimal | 13 | |||
Credits | pDecimal | 13 | |||
TotDeprTaken | pDecimal | 13 | |||
TotDeprElig | pDecimal | 13 | |||
YTDDepr | pDecimal | 13 | |||
AnnualDepr | pDecimal | 13 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |